package com.sxfq.loansupermarket.backsystem.modular.report.service;

import com.sxfq.loansupermarket.backsystem.modular.report.entity.SearchMarketReportInfo;
import com.sxfq.loansupermarket.backsystem.modular.report.entity.SearchMarketReportTwoInfo;

import java.util.List;

/**
 *
 *
 * @author py
 * @Date 2018年4月19日23:15:54
 */
public interface IGetTotleMarketTwoService {
    String  getsqlDepartmentTwo(SearchMarketReportTwoInfo searchInfo, String classification, String condition, int i, List<SearchMarketReportTwoInfo> list1);

    String getsqlMarketPersonnel(SearchMarketReportTwoInfo searchInfo, String channel, String classification,
                                 int i, List<SearchMarketReportInfo> list1, String simplename,
                                 String condition, String condition1, String condition2, String condition3);

    String getsqlHospitalWide(SearchMarketReportTwoInfo searchInfo, String channel,  String simplename,
                              String condition, String condition1, String condition2, String condition3);

    String getTotleSqlDepartmentTwo(SearchMarketReportTwoInfo searchInfo);

    String getsqlDepartmentsTwo(SearchMarketReportTwoInfo searchInfo, String classification, String condition);

    String getsqlDepartment(SearchMarketReportTwoInfo searchInfo, String channel, String condition,
                            int i, List<SearchMarketReportTwoInfo> list1, String abbreviation, String simplename,
                            String condition1,String condition2,String condition3,String condition4,String condition5);

    String getTotleDepartmentSql(SearchMarketReportTwoInfo searchInfo, String channel, String condition, String abbreviation,
                                 String condition1,String condition2,String condition3,String condition4,String conditions1);
}
